package com.ttj.domain.oracle.gen;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SysconfParamsCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer mysqlOffset;

    protected Integer mysqlLength;

    public SysconfParamsCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlOffset(Integer mysqlOffset) {
        this.mysqlOffset=mysqlOffset;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlOffset() {
        return mysqlOffset;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlLength(Integer mysqlLength) {
        this.mysqlLength=mysqlLength;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlLength() {
        return mysqlLength;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andSellPointIsNull() {
            addCriterion("SELL_POINT is null");
            return (Criteria) this;
        }

        public Criteria andSellPointIsNotNull() {
            addCriterion("SELL_POINT is not null");
            return (Criteria) this;
        }

        public Criteria andSellPointEqualTo(Integer value) {
            addCriterion("SELL_POINT =", value, "sellPoint");
            return (Criteria) this;
        }

        public Criteria andSellPointNotEqualTo(Integer value) {
            addCriterion("SELL_POINT <>", value, "sellPoint");
            return (Criteria) this;
        }

        public Criteria andSellPointGreaterThan(Integer value) {
            addCriterion("SELL_POINT >", value, "sellPoint");
            return (Criteria) this;
        }

        public Criteria andSellPointGreaterThanOrEqualTo(Integer value) {
            addCriterion("SELL_POINT >=", value, "sellPoint");
            return (Criteria) this;
        }

        public Criteria andSellPointLessThan(Integer value) {
            addCriterion("SELL_POINT <", value, "sellPoint");
            return (Criteria) this;
        }

        public Criteria andSellPointLessThanOrEqualTo(Integer value) {
            addCriterion("SELL_POINT <=", value, "sellPoint");
            return (Criteria) this;
        }

        public Criteria andSellPointIn(List<Integer> values) {
            addCriterion("SELL_POINT in", values, "sellPoint");
            return (Criteria) this;
        }

        public Criteria andSellPointNotIn(List<Integer> values) {
            addCriterion("SELL_POINT not in", values, "sellPoint");
            return (Criteria) this;
        }

        public Criteria andSellPointBetween(Integer value1, Integer value2) {
            addCriterion("SELL_POINT between", value1, value2, "sellPoint");
            return (Criteria) this;
        }

        public Criteria andSellPointNotBetween(Integer value1, Integer value2) {
            addCriterion("SELL_POINT not between", value1, value2, "sellPoint");
            return (Criteria) this;
        }

        public Criteria andRecPointIsNull() {
            addCriterion("REC_POINT is null");
            return (Criteria) this;
        }

        public Criteria andRecPointIsNotNull() {
            addCriterion("REC_POINT is not null");
            return (Criteria) this;
        }

        public Criteria andRecPointEqualTo(Integer value) {
            addCriterion("REC_POINT =", value, "recPoint");
            return (Criteria) this;
        }

        public Criteria andRecPointNotEqualTo(Integer value) {
            addCriterion("REC_POINT <>", value, "recPoint");
            return (Criteria) this;
        }

        public Criteria andRecPointGreaterThan(Integer value) {
            addCriterion("REC_POINT >", value, "recPoint");
            return (Criteria) this;
        }

        public Criteria andRecPointGreaterThanOrEqualTo(Integer value) {
            addCriterion("REC_POINT >=", value, "recPoint");
            return (Criteria) this;
        }

        public Criteria andRecPointLessThan(Integer value) {
            addCriterion("REC_POINT <", value, "recPoint");
            return (Criteria) this;
        }

        public Criteria andRecPointLessThanOrEqualTo(Integer value) {
            addCriterion("REC_POINT <=", value, "recPoint");
            return (Criteria) this;
        }

        public Criteria andRecPointIn(List<Integer> values) {
            addCriterion("REC_POINT in", values, "recPoint");
            return (Criteria) this;
        }

        public Criteria andRecPointNotIn(List<Integer> values) {
            addCriterion("REC_POINT not in", values, "recPoint");
            return (Criteria) this;
        }

        public Criteria andRecPointBetween(Integer value1, Integer value2) {
            addCriterion("REC_POINT between", value1, value2, "recPoint");
            return (Criteria) this;
        }

        public Criteria andRecPointNotBetween(Integer value1, Integer value2) {
            addCriterion("REC_POINT not between", value1, value2, "recPoint");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodIsNull() {
            addCriterion("EXCHANGE_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodIsNotNull() {
            addCriterion("EXCHANGE_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodEqualTo(Integer value) {
            addCriterion("EXCHANGE_METHOD =", value, "exchangeMethod");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodNotEqualTo(Integer value) {
            addCriterion("EXCHANGE_METHOD <>", value, "exchangeMethod");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodGreaterThan(Integer value) {
            addCriterion("EXCHANGE_METHOD >", value, "exchangeMethod");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodGreaterThanOrEqualTo(Integer value) {
            addCriterion("EXCHANGE_METHOD >=", value, "exchangeMethod");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodLessThan(Integer value) {
            addCriterion("EXCHANGE_METHOD <", value, "exchangeMethod");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodLessThanOrEqualTo(Integer value) {
            addCriterion("EXCHANGE_METHOD <=", value, "exchangeMethod");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodIn(List<Integer> values) {
            addCriterion("EXCHANGE_METHOD in", values, "exchangeMethod");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodNotIn(List<Integer> values) {
            addCriterion("EXCHANGE_METHOD not in", values, "exchangeMethod");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodBetween(Integer value1, Integer value2) {
            addCriterion("EXCHANGE_METHOD between", value1, value2, "exchangeMethod");
            return (Criteria) this;
        }

        public Criteria andExchangeMethodNotBetween(Integer value1, Integer value2) {
            addCriterion("EXCHANGE_METHOD not between", value1, value2, "exchangeMethod");
            return (Criteria) this;
        }

        public Criteria andStockAlertIsNull() {
            addCriterion("STOCK_ALERT is null");
            return (Criteria) this;
        }

        public Criteria andStockAlertIsNotNull() {
            addCriterion("STOCK_ALERT is not null");
            return (Criteria) this;
        }

        public Criteria andStockAlertEqualTo(Integer value) {
            addCriterion("STOCK_ALERT =", value, "stockAlert");
            return (Criteria) this;
        }

        public Criteria andStockAlertNotEqualTo(Integer value) {
            addCriterion("STOCK_ALERT <>", value, "stockAlert");
            return (Criteria) this;
        }

        public Criteria andStockAlertGreaterThan(Integer value) {
            addCriterion("STOCK_ALERT >", value, "stockAlert");
            return (Criteria) this;
        }

        public Criteria andStockAlertGreaterThanOrEqualTo(Integer value) {
            addCriterion("STOCK_ALERT >=", value, "stockAlert");
            return (Criteria) this;
        }

        public Criteria andStockAlertLessThan(Integer value) {
            addCriterion("STOCK_ALERT <", value, "stockAlert");
            return (Criteria) this;
        }

        public Criteria andStockAlertLessThanOrEqualTo(Integer value) {
            addCriterion("STOCK_ALERT <=", value, "stockAlert");
            return (Criteria) this;
        }

        public Criteria andStockAlertIn(List<Integer> values) {
            addCriterion("STOCK_ALERT in", values, "stockAlert");
            return (Criteria) this;
        }

        public Criteria andStockAlertNotIn(List<Integer> values) {
            addCriterion("STOCK_ALERT not in", values, "stockAlert");
            return (Criteria) this;
        }

        public Criteria andStockAlertBetween(Integer value1, Integer value2) {
            addCriterion("STOCK_ALERT between", value1, value2, "stockAlert");
            return (Criteria) this;
        }

        public Criteria andStockAlertNotBetween(Integer value1, Integer value2) {
            addCriterion("STOCK_ALERT not between", value1, value2, "stockAlert");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertIsNull() {
            addCriterion("PRIZE_ALERT is null");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertIsNotNull() {
            addCriterion("PRIZE_ALERT is not null");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertEqualTo(Integer value) {
            addCriterion("PRIZE_ALERT =", value, "prizeAlert");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertNotEqualTo(Integer value) {
            addCriterion("PRIZE_ALERT <>", value, "prizeAlert");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertGreaterThan(Integer value) {
            addCriterion("PRIZE_ALERT >", value, "prizeAlert");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertGreaterThanOrEqualTo(Integer value) {
            addCriterion("PRIZE_ALERT >=", value, "prizeAlert");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertLessThan(Integer value) {
            addCriterion("PRIZE_ALERT <", value, "prizeAlert");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertLessThanOrEqualTo(Integer value) {
            addCriterion("PRIZE_ALERT <=", value, "prizeAlert");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertIn(List<Integer> values) {
            addCriterion("PRIZE_ALERT in", values, "prizeAlert");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertNotIn(List<Integer> values) {
            addCriterion("PRIZE_ALERT not in", values, "prizeAlert");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertBetween(Integer value1, Integer value2) {
            addCriterion("PRIZE_ALERT between", value1, value2, "prizeAlert");
            return (Criteria) this;
        }

        public Criteria andPrizeAlertNotBetween(Integer value1, Integer value2) {
            addCriterion("PRIZE_ALERT not between", value1, value2, "prizeAlert");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitIsNull() {
            addCriterion("ORDER_CANCEL_LIMIT is null");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitIsNotNull() {
            addCriterion("ORDER_CANCEL_LIMIT is not null");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitEqualTo(Integer value) {
            addCriterion("ORDER_CANCEL_LIMIT =", value, "orderCancelLimit");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitNotEqualTo(Integer value) {
            addCriterion("ORDER_CANCEL_LIMIT <>", value, "orderCancelLimit");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitGreaterThan(Integer value) {
            addCriterion("ORDER_CANCEL_LIMIT >", value, "orderCancelLimit");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitGreaterThanOrEqualTo(Integer value) {
            addCriterion("ORDER_CANCEL_LIMIT >=", value, "orderCancelLimit");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitLessThan(Integer value) {
            addCriterion("ORDER_CANCEL_LIMIT <", value, "orderCancelLimit");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitLessThanOrEqualTo(Integer value) {
            addCriterion("ORDER_CANCEL_LIMIT <=", value, "orderCancelLimit");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitIn(List<Integer> values) {
            addCriterion("ORDER_CANCEL_LIMIT in", values, "orderCancelLimit");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitNotIn(List<Integer> values) {
            addCriterion("ORDER_CANCEL_LIMIT not in", values, "orderCancelLimit");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_CANCEL_LIMIT between", value1, value2, "orderCancelLimit");
            return (Criteria) this;
        }

        public Criteria andOrderCancelLimitNotBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_CANCEL_LIMIT not between", value1, value2, "orderCancelLimit");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitIsNull() {
            addCriterion("EXCHANGE_POINT_LIMIT is null");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitIsNotNull() {
            addCriterion("EXCHANGE_POINT_LIMIT is not null");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitEqualTo(Integer value) {
            addCriterion("EXCHANGE_POINT_LIMIT =", value, "exchangePointLimit");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitNotEqualTo(Integer value) {
            addCriterion("EXCHANGE_POINT_LIMIT <>", value, "exchangePointLimit");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitGreaterThan(Integer value) {
            addCriterion("EXCHANGE_POINT_LIMIT >", value, "exchangePointLimit");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitGreaterThanOrEqualTo(Integer value) {
            addCriterion("EXCHANGE_POINT_LIMIT >=", value, "exchangePointLimit");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitLessThan(Integer value) {
            addCriterion("EXCHANGE_POINT_LIMIT <", value, "exchangePointLimit");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitLessThanOrEqualTo(Integer value) {
            addCriterion("EXCHANGE_POINT_LIMIT <=", value, "exchangePointLimit");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitIn(List<Integer> values) {
            addCriterion("EXCHANGE_POINT_LIMIT in", values, "exchangePointLimit");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitNotIn(List<Integer> values) {
            addCriterion("EXCHANGE_POINT_LIMIT not in", values, "exchangePointLimit");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitBetween(Integer value1, Integer value2) {
            addCriterion("EXCHANGE_POINT_LIMIT between", value1, value2, "exchangePointLimit");
            return (Criteria) this;
        }

        public Criteria andExchangePointLimitNotBetween(Integer value1, Integer value2) {
            addCriterion("EXCHANGE_POINT_LIMIT not between", value1, value2, "exchangePointLimit");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartIsNull() {
            addCriterion("ORDER_SUBMIT_START is null");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartIsNotNull() {
            addCriterion("ORDER_SUBMIT_START is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartEqualTo(Integer value) {
            addCriterion("ORDER_SUBMIT_START =", value, "orderSubmitStart");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartNotEqualTo(Integer value) {
            addCriterion("ORDER_SUBMIT_START <>", value, "orderSubmitStart");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartGreaterThan(Integer value) {
            addCriterion("ORDER_SUBMIT_START >", value, "orderSubmitStart");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartGreaterThanOrEqualTo(Integer value) {
            addCriterion("ORDER_SUBMIT_START >=", value, "orderSubmitStart");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartLessThan(Integer value) {
            addCriterion("ORDER_SUBMIT_START <", value, "orderSubmitStart");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartLessThanOrEqualTo(Integer value) {
            addCriterion("ORDER_SUBMIT_START <=", value, "orderSubmitStart");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartIn(List<Integer> values) {
            addCriterion("ORDER_SUBMIT_START in", values, "orderSubmitStart");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartNotIn(List<Integer> values) {
            addCriterion("ORDER_SUBMIT_START not in", values, "orderSubmitStart");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_SUBMIT_START between", value1, value2, "orderSubmitStart");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitStartNotBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_SUBMIT_START not between", value1, value2, "orderSubmitStart");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndIsNull() {
            addCriterion("ORDER_SUBMIT_END is null");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndIsNotNull() {
            addCriterion("ORDER_SUBMIT_END is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndEqualTo(Integer value) {
            addCriterion("ORDER_SUBMIT_END =", value, "orderSubmitEnd");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndNotEqualTo(Integer value) {
            addCriterion("ORDER_SUBMIT_END <>", value, "orderSubmitEnd");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndGreaterThan(Integer value) {
            addCriterion("ORDER_SUBMIT_END >", value, "orderSubmitEnd");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndGreaterThanOrEqualTo(Integer value) {
            addCriterion("ORDER_SUBMIT_END >=", value, "orderSubmitEnd");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndLessThan(Integer value) {
            addCriterion("ORDER_SUBMIT_END <", value, "orderSubmitEnd");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndLessThanOrEqualTo(Integer value) {
            addCriterion("ORDER_SUBMIT_END <=", value, "orderSubmitEnd");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndIn(List<Integer> values) {
            addCriterion("ORDER_SUBMIT_END in", values, "orderSubmitEnd");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndNotIn(List<Integer> values) {
            addCriterion("ORDER_SUBMIT_END not in", values, "orderSubmitEnd");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_SUBMIT_END between", value1, value2, "orderSubmitEnd");
            return (Criteria) this;
        }

        public Criteria andOrderSubmitEndNotBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_SUBMIT_END not between", value1, value2, "orderSubmitEnd");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointIsNull() {
            addCriterion("CANCELORDER_PUNISH_POINT is null");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointIsNotNull() {
            addCriterion("CANCELORDER_PUNISH_POINT is not null");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointEqualTo(Integer value) {
            addCriterion("CANCELORDER_PUNISH_POINT =", value, "cancelorderPunishPoint");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointNotEqualTo(Integer value) {
            addCriterion("CANCELORDER_PUNISH_POINT <>", value, "cancelorderPunishPoint");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointGreaterThan(Integer value) {
            addCriterion("CANCELORDER_PUNISH_POINT >", value, "cancelorderPunishPoint");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointGreaterThanOrEqualTo(Integer value) {
            addCriterion("CANCELORDER_PUNISH_POINT >=", value, "cancelorderPunishPoint");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointLessThan(Integer value) {
            addCriterion("CANCELORDER_PUNISH_POINT <", value, "cancelorderPunishPoint");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointLessThanOrEqualTo(Integer value) {
            addCriterion("CANCELORDER_PUNISH_POINT <=", value, "cancelorderPunishPoint");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointIn(List<Integer> values) {
            addCriterion("CANCELORDER_PUNISH_POINT in", values, "cancelorderPunishPoint");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointNotIn(List<Integer> values) {
            addCriterion("CANCELORDER_PUNISH_POINT not in", values, "cancelorderPunishPoint");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointBetween(Integer value1, Integer value2) {
            addCriterion("CANCELORDER_PUNISH_POINT between", value1, value2, "cancelorderPunishPoint");
            return (Criteria) this;
        }

        public Criteria andCancelorderPunishPointNotBetween(Integer value1, Integer value2) {
            addCriterion("CANCELORDER_PUNISH_POINT not between", value1, value2, "cancelorderPunishPoint");
            return (Criteria) this;
        }

        public Criteria andRecWeightIsNull() {
            addCriterion("REC_WEIGHT is null");
            return (Criteria) this;
        }

        public Criteria andRecWeightIsNotNull() {
            addCriterion("REC_WEIGHT is not null");
            return (Criteria) this;
        }

        public Criteria andRecWeightEqualTo(Integer value) {
            addCriterion("REC_WEIGHT =", value, "recWeight");
            return (Criteria) this;
        }

        public Criteria andRecWeightNotEqualTo(Integer value) {
            addCriterion("REC_WEIGHT <>", value, "recWeight");
            return (Criteria) this;
        }

        public Criteria andRecWeightGreaterThan(Integer value) {
            addCriterion("REC_WEIGHT >", value, "recWeight");
            return (Criteria) this;
        }

        public Criteria andRecWeightGreaterThanOrEqualTo(Integer value) {
            addCriterion("REC_WEIGHT >=", value, "recWeight");
            return (Criteria) this;
        }

        public Criteria andRecWeightLessThan(Integer value) {
            addCriterion("REC_WEIGHT <", value, "recWeight");
            return (Criteria) this;
        }

        public Criteria andRecWeightLessThanOrEqualTo(Integer value) {
            addCriterion("REC_WEIGHT <=", value, "recWeight");
            return (Criteria) this;
        }

        public Criteria andRecWeightIn(List<Integer> values) {
            addCriterion("REC_WEIGHT in", values, "recWeight");
            return (Criteria) this;
        }

        public Criteria andRecWeightNotIn(List<Integer> values) {
            addCriterion("REC_WEIGHT not in", values, "recWeight");
            return (Criteria) this;
        }

        public Criteria andRecWeightBetween(Integer value1, Integer value2) {
            addCriterion("REC_WEIGHT between", value1, value2, "recWeight");
            return (Criteria) this;
        }

        public Criteria andRecWeightNotBetween(Integer value1, Integer value2) {
            addCriterion("REC_WEIGHT not between", value1, value2, "recWeight");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardIsNull() {
            addCriterion("REC_WEIGHT_REWARD is null");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardIsNotNull() {
            addCriterion("REC_WEIGHT_REWARD is not null");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardEqualTo(Integer value) {
            addCriterion("REC_WEIGHT_REWARD =", value, "recWeightReward");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardNotEqualTo(Integer value) {
            addCriterion("REC_WEIGHT_REWARD <>", value, "recWeightReward");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardGreaterThan(Integer value) {
            addCriterion("REC_WEIGHT_REWARD >", value, "recWeightReward");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardGreaterThanOrEqualTo(Integer value) {
            addCriterion("REC_WEIGHT_REWARD >=", value, "recWeightReward");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardLessThan(Integer value) {
            addCriterion("REC_WEIGHT_REWARD <", value, "recWeightReward");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardLessThanOrEqualTo(Integer value) {
            addCriterion("REC_WEIGHT_REWARD <=", value, "recWeightReward");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardIn(List<Integer> values) {
            addCriterion("REC_WEIGHT_REWARD in", values, "recWeightReward");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardNotIn(List<Integer> values) {
            addCriterion("REC_WEIGHT_REWARD not in", values, "recWeightReward");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardBetween(Integer value1, Integer value2) {
            addCriterion("REC_WEIGHT_REWARD between", value1, value2, "recWeightReward");
            return (Criteria) this;
        }

        public Criteria andRecWeightRewardNotBetween(Integer value1, Integer value2) {
            addCriterion("REC_WEIGHT_REWARD not between", value1, value2, "recWeightReward");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitIsNull() {
            addCriterion("PURCHASE_AUDIT_LIMIT is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitIsNotNull() {
            addCriterion("PURCHASE_AUDIT_LIMIT is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitEqualTo(Double value) {
            addCriterion("PURCHASE_AUDIT_LIMIT =", value, "purchaseAuditLimit");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitNotEqualTo(Double value) {
            addCriterion("PURCHASE_AUDIT_LIMIT <>", value, "purchaseAuditLimit");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitGreaterThan(Double value) {
            addCriterion("PURCHASE_AUDIT_LIMIT >", value, "purchaseAuditLimit");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitGreaterThanOrEqualTo(Double value) {
            addCriterion("PURCHASE_AUDIT_LIMIT >=", value, "purchaseAuditLimit");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitLessThan(Double value) {
            addCriterion("PURCHASE_AUDIT_LIMIT <", value, "purchaseAuditLimit");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitLessThanOrEqualTo(Double value) {
            addCriterion("PURCHASE_AUDIT_LIMIT <=", value, "purchaseAuditLimit");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitIn(List<Double> values) {
            addCriterion("PURCHASE_AUDIT_LIMIT in", values, "purchaseAuditLimit");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitNotIn(List<Double> values) {
            addCriterion("PURCHASE_AUDIT_LIMIT not in", values, "purchaseAuditLimit");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitBetween(Double value1, Double value2) {
            addCriterion("PURCHASE_AUDIT_LIMIT between", value1, value2, "purchaseAuditLimit");
            return (Criteria) this;
        }

        public Criteria andPurchaseAuditLimitNotBetween(Double value1, Double value2) {
            addCriterion("PURCHASE_AUDIT_LIMIT not between", value1, value2, "purchaseAuditLimit");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitIsNull() {
            addCriterion("PIMP_CUSTOMER_LIMIT is null");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitIsNotNull() {
            addCriterion("PIMP_CUSTOMER_LIMIT is not null");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitEqualTo(Double value) {
            addCriterion("PIMP_CUSTOMER_LIMIT =", value, "pimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitNotEqualTo(Double value) {
            addCriterion("PIMP_CUSTOMER_LIMIT <>", value, "pimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitGreaterThan(Double value) {
            addCriterion("PIMP_CUSTOMER_LIMIT >", value, "pimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitGreaterThanOrEqualTo(Double value) {
            addCriterion("PIMP_CUSTOMER_LIMIT >=", value, "pimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitLessThan(Double value) {
            addCriterion("PIMP_CUSTOMER_LIMIT <", value, "pimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitLessThanOrEqualTo(Double value) {
            addCriterion("PIMP_CUSTOMER_LIMIT <=", value, "pimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitIn(List<Double> values) {
            addCriterion("PIMP_CUSTOMER_LIMIT in", values, "pimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitNotIn(List<Double> values) {
            addCriterion("PIMP_CUSTOMER_LIMIT not in", values, "pimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitBetween(Double value1, Double value2) {
            addCriterion("PIMP_CUSTOMER_LIMIT between", value1, value2, "pimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPimpCustomerLimitNotBetween(Double value1, Double value2) {
            addCriterion("PIMP_CUSTOMER_LIMIT not between", value1, value2, "pimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitIsNull() {
            addCriterion("PGEN_CUSTOMER_LIMIT is null");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitIsNotNull() {
            addCriterion("PGEN_CUSTOMER_LIMIT is not null");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitEqualTo(Double value) {
            addCriterion("PGEN_CUSTOMER_LIMIT =", value, "pgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitNotEqualTo(Double value) {
            addCriterion("PGEN_CUSTOMER_LIMIT <>", value, "pgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitGreaterThan(Double value) {
            addCriterion("PGEN_CUSTOMER_LIMIT >", value, "pgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitGreaterThanOrEqualTo(Double value) {
            addCriterion("PGEN_CUSTOMER_LIMIT >=", value, "pgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitLessThan(Double value) {
            addCriterion("PGEN_CUSTOMER_LIMIT <", value, "pgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitLessThanOrEqualTo(Double value) {
            addCriterion("PGEN_CUSTOMER_LIMIT <=", value, "pgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitIn(List<Double> values) {
            addCriterion("PGEN_CUSTOMER_LIMIT in", values, "pgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitNotIn(List<Double> values) {
            addCriterion("PGEN_CUSTOMER_LIMIT not in", values, "pgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitBetween(Double value1, Double value2) {
            addCriterion("PGEN_CUSTOMER_LIMIT between", value1, value2, "pgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andPgenCustomerLimitNotBetween(Double value1, Double value2) {
            addCriterion("PGEN_CUSTOMER_LIMIT not between", value1, value2, "pgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitIsNull() {
            addCriterion("RIMP_CUSTOMER_LIMIT is null");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitIsNotNull() {
            addCriterion("RIMP_CUSTOMER_LIMIT is not null");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitEqualTo(Double value) {
            addCriterion("RIMP_CUSTOMER_LIMIT =", value, "rimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitNotEqualTo(Double value) {
            addCriterion("RIMP_CUSTOMER_LIMIT <>", value, "rimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitGreaterThan(Double value) {
            addCriterion("RIMP_CUSTOMER_LIMIT >", value, "rimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitGreaterThanOrEqualTo(Double value) {
            addCriterion("RIMP_CUSTOMER_LIMIT >=", value, "rimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitLessThan(Double value) {
            addCriterion("RIMP_CUSTOMER_LIMIT <", value, "rimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitLessThanOrEqualTo(Double value) {
            addCriterion("RIMP_CUSTOMER_LIMIT <=", value, "rimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitIn(List<Double> values) {
            addCriterion("RIMP_CUSTOMER_LIMIT in", values, "rimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitNotIn(List<Double> values) {
            addCriterion("RIMP_CUSTOMER_LIMIT not in", values, "rimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitBetween(Double value1, Double value2) {
            addCriterion("RIMP_CUSTOMER_LIMIT between", value1, value2, "rimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRimpCustomerLimitNotBetween(Double value1, Double value2) {
            addCriterion("RIMP_CUSTOMER_LIMIT not between", value1, value2, "rimpCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitIsNull() {
            addCriterion("RGEN_CUSTOMER_LIMIT is null");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitIsNotNull() {
            addCriterion("RGEN_CUSTOMER_LIMIT is not null");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitEqualTo(Double value) {
            addCriterion("RGEN_CUSTOMER_LIMIT =", value, "rgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitNotEqualTo(Double value) {
            addCriterion("RGEN_CUSTOMER_LIMIT <>", value, "rgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitGreaterThan(Double value) {
            addCriterion("RGEN_CUSTOMER_LIMIT >", value, "rgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitGreaterThanOrEqualTo(Double value) {
            addCriterion("RGEN_CUSTOMER_LIMIT >=", value, "rgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitLessThan(Double value) {
            addCriterion("RGEN_CUSTOMER_LIMIT <", value, "rgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitLessThanOrEqualTo(Double value) {
            addCriterion("RGEN_CUSTOMER_LIMIT <=", value, "rgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitIn(List<Double> values) {
            addCriterion("RGEN_CUSTOMER_LIMIT in", values, "rgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitNotIn(List<Double> values) {
            addCriterion("RGEN_CUSTOMER_LIMIT not in", values, "rgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitBetween(Double value1, Double value2) {
            addCriterion("RGEN_CUSTOMER_LIMIT between", value1, value2, "rgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andRgenCustomerLimitNotBetween(Double value1, Double value2) {
            addCriterion("RGEN_CUSTOMER_LIMIT not between", value1, value2, "rgenCustomerLimit");
            return (Criteria) this;
        }

        public Criteria andModifTimeIsNull() {
            addCriterion("MODIF_TIME is null");
            return (Criteria) this;
        }

        public Criteria andModifTimeIsNotNull() {
            addCriterion("MODIF_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andModifTimeEqualTo(Date value) {
            addCriterion("MODIF_TIME =", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotEqualTo(Date value) {
            addCriterion("MODIF_TIME <>", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeGreaterThan(Date value) {
            addCriterion("MODIF_TIME >", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("MODIF_TIME >=", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeLessThan(Date value) {
            addCriterion("MODIF_TIME <", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeLessThanOrEqualTo(Date value) {
            addCriterion("MODIF_TIME <=", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeIn(List<Date> values) {
            addCriterion("MODIF_TIME in", values, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotIn(List<Date> values) {
            addCriterion("MODIF_TIME not in", values, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeBetween(Date value1, Date value2) {
            addCriterion("MODIF_TIME between", value1, value2, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotBetween(Date value1, Date value2) {
            addCriterion("MODIF_TIME not between", value1, value2, "modifTime");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeIsNull() {
            addCriterion("SELL_POINT_START_TIME is null");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeIsNotNull() {
            addCriterion("SELL_POINT_START_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeEqualTo(Date value) {
            addCriterion("SELL_POINT_START_TIME =", value, "sellPointStartTime");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeNotEqualTo(Date value) {
            addCriterion("SELL_POINT_START_TIME <>", value, "sellPointStartTime");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeGreaterThan(Date value) {
            addCriterion("SELL_POINT_START_TIME >", value, "sellPointStartTime");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("SELL_POINT_START_TIME >=", value, "sellPointStartTime");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeLessThan(Date value) {
            addCriterion("SELL_POINT_START_TIME <", value, "sellPointStartTime");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("SELL_POINT_START_TIME <=", value, "sellPointStartTime");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeIn(List<Date> values) {
            addCriterion("SELL_POINT_START_TIME in", values, "sellPointStartTime");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeNotIn(List<Date> values) {
            addCriterion("SELL_POINT_START_TIME not in", values, "sellPointStartTime");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeBetween(Date value1, Date value2) {
            addCriterion("SELL_POINT_START_TIME between", value1, value2, "sellPointStartTime");
            return (Criteria) this;
        }

        public Criteria andSellPointStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("SELL_POINT_START_TIME not between", value1, value2, "sellPointStartTime");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeIsNull() {
            addCriterion("SELL_POINT_END_TIME is null");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeIsNotNull() {
            addCriterion("SELL_POINT_END_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeEqualTo(Date value) {
            addCriterion("SELL_POINT_END_TIME =", value, "sellPointEndTime");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeNotEqualTo(Date value) {
            addCriterion("SELL_POINT_END_TIME <>", value, "sellPointEndTime");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeGreaterThan(Date value) {
            addCriterion("SELL_POINT_END_TIME >", value, "sellPointEndTime");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("SELL_POINT_END_TIME >=", value, "sellPointEndTime");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeLessThan(Date value) {
            addCriterion("SELL_POINT_END_TIME <", value, "sellPointEndTime");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("SELL_POINT_END_TIME <=", value, "sellPointEndTime");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeIn(List<Date> values) {
            addCriterion("SELL_POINT_END_TIME in", values, "sellPointEndTime");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeNotIn(List<Date> values) {
            addCriterion("SELL_POINT_END_TIME not in", values, "sellPointEndTime");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeBetween(Date value1, Date value2) {
            addCriterion("SELL_POINT_END_TIME between", value1, value2, "sellPointEndTime");
            return (Criteria) this;
        }

        public Criteria andSellPointEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("SELL_POINT_END_TIME not between", value1, value2, "sellPointEndTime");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeIsNull() {
            addCriterion("REC_POINT_START_TIME is null");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeIsNotNull() {
            addCriterion("REC_POINT_START_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeEqualTo(Date value) {
            addCriterion("REC_POINT_START_TIME =", value, "recPointStartTime");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeNotEqualTo(Date value) {
            addCriterion("REC_POINT_START_TIME <>", value, "recPointStartTime");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeGreaterThan(Date value) {
            addCriterion("REC_POINT_START_TIME >", value, "recPointStartTime");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("REC_POINT_START_TIME >=", value, "recPointStartTime");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeLessThan(Date value) {
            addCriterion("REC_POINT_START_TIME <", value, "recPointStartTime");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeLessThanOrEqualTo(Date value) {
            addCriterion("REC_POINT_START_TIME <=", value, "recPointStartTime");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeIn(List<Date> values) {
            addCriterion("REC_POINT_START_TIME in", values, "recPointStartTime");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeNotIn(List<Date> values) {
            addCriterion("REC_POINT_START_TIME not in", values, "recPointStartTime");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeBetween(Date value1, Date value2) {
            addCriterion("REC_POINT_START_TIME between", value1, value2, "recPointStartTime");
            return (Criteria) this;
        }

        public Criteria andRecPointStartTimeNotBetween(Date value1, Date value2) {
            addCriterion("REC_POINT_START_TIME not between", value1, value2, "recPointStartTime");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeIsNull() {
            addCriterion("REC_POINT_END_TIME is null");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeIsNotNull() {
            addCriterion("REC_POINT_END_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeEqualTo(Date value) {
            addCriterion("REC_POINT_END_TIME =", value, "recPointEndTime");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeNotEqualTo(Date value) {
            addCriterion("REC_POINT_END_TIME <>", value, "recPointEndTime");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeGreaterThan(Date value) {
            addCriterion("REC_POINT_END_TIME >", value, "recPointEndTime");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("REC_POINT_END_TIME >=", value, "recPointEndTime");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeLessThan(Date value) {
            addCriterion("REC_POINT_END_TIME <", value, "recPointEndTime");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeLessThanOrEqualTo(Date value) {
            addCriterion("REC_POINT_END_TIME <=", value, "recPointEndTime");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeIn(List<Date> values) {
            addCriterion("REC_POINT_END_TIME in", values, "recPointEndTime");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeNotIn(List<Date> values) {
            addCriterion("REC_POINT_END_TIME not in", values, "recPointEndTime");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeBetween(Date value1, Date value2) {
            addCriterion("REC_POINT_END_TIME between", value1, value2, "recPointEndTime");
            return (Criteria) this;
        }

        public Criteria andRecPointEndTimeNotBetween(Date value1, Date value2) {
            addCriterion("REC_POINT_END_TIME not between", value1, value2, "recPointEndTime");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeIsNull() {
            addCriterion("CUSTOMER_DEL_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeIsNotNull() {
            addCriterion("CUSTOMER_DEL_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeEqualTo(Integer value) {
            addCriterion("CUSTOMER_DEL_TIME =", value, "customerDelTime");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeNotEqualTo(Integer value) {
            addCriterion("CUSTOMER_DEL_TIME <>", value, "customerDelTime");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeGreaterThan(Integer value) {
            addCriterion("CUSTOMER_DEL_TIME >", value, "customerDelTime");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeGreaterThanOrEqualTo(Integer value) {
            addCriterion("CUSTOMER_DEL_TIME >=", value, "customerDelTime");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeLessThan(Integer value) {
            addCriterion("CUSTOMER_DEL_TIME <", value, "customerDelTime");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeLessThanOrEqualTo(Integer value) {
            addCriterion("CUSTOMER_DEL_TIME <=", value, "customerDelTime");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeIn(List<Integer> values) {
            addCriterion("CUSTOMER_DEL_TIME in", values, "customerDelTime");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeNotIn(List<Integer> values) {
            addCriterion("CUSTOMER_DEL_TIME not in", values, "customerDelTime");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeBetween(Integer value1, Integer value2) {
            addCriterion("CUSTOMER_DEL_TIME between", value1, value2, "customerDelTime");
            return (Criteria) this;
        }

        public Criteria andCustomerDelTimeNotBetween(Integer value1, Integer value2) {
            addCriterion("CUSTOMER_DEL_TIME not between", value1, value2, "customerDelTime");
            return (Criteria) this;
        }

        public Criteria andSellPointCompIsNull() {
            addCriterion("SELL_POINT_COMP is null");
            return (Criteria) this;
        }

        public Criteria andSellPointCompIsNotNull() {
            addCriterion("SELL_POINT_COMP is not null");
            return (Criteria) this;
        }

        public Criteria andSellPointCompEqualTo(Integer value) {
            addCriterion("SELL_POINT_COMP =", value, "sellPointComp");
            return (Criteria) this;
        }

        public Criteria andSellPointCompNotEqualTo(Integer value) {
            addCriterion("SELL_POINT_COMP <>", value, "sellPointComp");
            return (Criteria) this;
        }

        public Criteria andSellPointCompGreaterThan(Integer value) {
            addCriterion("SELL_POINT_COMP >", value, "sellPointComp");
            return (Criteria) this;
        }

        public Criteria andSellPointCompGreaterThanOrEqualTo(Integer value) {
            addCriterion("SELL_POINT_COMP >=", value, "sellPointComp");
            return (Criteria) this;
        }

        public Criteria andSellPointCompLessThan(Integer value) {
            addCriterion("SELL_POINT_COMP <", value, "sellPointComp");
            return (Criteria) this;
        }

        public Criteria andSellPointCompLessThanOrEqualTo(Integer value) {
            addCriterion("SELL_POINT_COMP <=", value, "sellPointComp");
            return (Criteria) this;
        }

        public Criteria andSellPointCompIn(List<Integer> values) {
            addCriterion("SELL_POINT_COMP in", values, "sellPointComp");
            return (Criteria) this;
        }

        public Criteria andSellPointCompNotIn(List<Integer> values) {
            addCriterion("SELL_POINT_COMP not in", values, "sellPointComp");
            return (Criteria) this;
        }

        public Criteria andSellPointCompBetween(Integer value1, Integer value2) {
            addCriterion("SELL_POINT_COMP between", value1, value2, "sellPointComp");
            return (Criteria) this;
        }

        public Criteria andSellPointCompNotBetween(Integer value1, Integer value2) {
            addCriterion("SELL_POINT_COMP not between", value1, value2, "sellPointComp");
            return (Criteria) this;
        }

        public Criteria andRecPointCompIsNull() {
            addCriterion("REC_POINT_COMP is null");
            return (Criteria) this;
        }

        public Criteria andRecPointCompIsNotNull() {
            addCriterion("REC_POINT_COMP is not null");
            return (Criteria) this;
        }

        public Criteria andRecPointCompEqualTo(Integer value) {
            addCriterion("REC_POINT_COMP =", value, "recPointComp");
            return (Criteria) this;
        }

        public Criteria andRecPointCompNotEqualTo(Integer value) {
            addCriterion("REC_POINT_COMP <>", value, "recPointComp");
            return (Criteria) this;
        }

        public Criteria andRecPointCompGreaterThan(Integer value) {
            addCriterion("REC_POINT_COMP >", value, "recPointComp");
            return (Criteria) this;
        }

        public Criteria andRecPointCompGreaterThanOrEqualTo(Integer value) {
            addCriterion("REC_POINT_COMP >=", value, "recPointComp");
            return (Criteria) this;
        }

        public Criteria andRecPointCompLessThan(Integer value) {
            addCriterion("REC_POINT_COMP <", value, "recPointComp");
            return (Criteria) this;
        }

        public Criteria andRecPointCompLessThanOrEqualTo(Integer value) {
            addCriterion("REC_POINT_COMP <=", value, "recPointComp");
            return (Criteria) this;
        }

        public Criteria andRecPointCompIn(List<Integer> values) {
            addCriterion("REC_POINT_COMP in", values, "recPointComp");
            return (Criteria) this;
        }

        public Criteria andRecPointCompNotIn(List<Integer> values) {
            addCriterion("REC_POINT_COMP not in", values, "recPointComp");
            return (Criteria) this;
        }

        public Criteria andRecPointCompBetween(Integer value1, Integer value2) {
            addCriterion("REC_POINT_COMP between", value1, value2, "recPointComp");
            return (Criteria) this;
        }

        public Criteria andRecPointCompNotBetween(Integer value1, Integer value2) {
            addCriterion("REC_POINT_COMP not between", value1, value2, "recPointComp");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table SYSCONF_PARAMS
     *
     * @mbg.generated do_not_delete_during_merge Wed Jul 12 08:41:20 CST 2017
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}